'''
how to use:
1) change XXXyourlinkXXX to the link preset, to batch open links.
'''

import math
import random
import numpy as np
import os
import xlrd
import webbrowser
import pandas as pd
import time

df = pd.read_excel("1.xlsx", sheet_name=0)     # add sheetname in so we can put all data in one excel
j = list()
i = 0
while (i < len(df)) :
    j.append(df.iloc[i][0].tolist())
    i = i + 1

i = 0
for a in j:
    i += 1
    b = "XXXyourlinkXXX"+str(a)
    webbrowser.open(b)
    print(i,a)
    time.sleep(0.8)
    if i == 20:
        break 

